package com.hongyan.dao;

import com.hongyan.bean.GradesS_InfoDto;
import com.hongyan.util.JDBCUtils;

import java.util.List;

public class GradesS_InfoDao {

    public static List<GradesS_InfoDto> getGradesS_InfoDtos() {
        String sql = "select s_info.s_id,s_info.sex,grades.grade FROM grades INNER JOIN s_info on grades.s_id =s_info.s_id;";
        List<GradesS_InfoDto> query = JDBCUtils.query(sql, GradesS_InfoDto.class);
        return query;
    }
}
